Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
SupplierID (FK)(PK) | A unique system assigned identifier for the Supplier. | ID_SPR | Identity | integer | DealSupplierItem(AS_ITM_DL_SPR) |
SupplierID (FK)(PK) | A unique system assigned identifier for the Supplier. | ID_SPR | Identity | integer | DealSupplierItem(AS_ITM_DL_SPR) |
DealCode (FK)(PK) | A code which uniquely identifies the type of DEAL offered by the SUPPLIER. For example the SUPPLIER may offer an additional 2% discount off the cost price, or increase the case units by 10% for the same cost price. Normally DEALs last for finite periods. | LU_DL | Code6 | char(6) | DealSupplierItem(AS_ITM_DL_SPR) |
SupplierItemCostPerUnitTypeCode (FK)(PK) | Defines the unit type the owned attribute costs are assigned to for this item. Valid unit types include: SALE UNIT, PACK UNIT and SHIP UNIT. A single SUPPLIER ITEM may in effect have 1 to three SUPPLIER ITEM BASE COST entities associated with it. | TY_UN_CST | Code2 | char(2) | DealSupplierItem(AS_ITM_DL_SPR) |
SupplierItemID (FK)(PK) | The code assigned by the supplier to uniquely identify the ITEM | ID_ITM_SPR | Identity | integer | DealSupplierItem(AS_ITM_DL_SPR) |
SupplierItemUnitDealThresholdCount (PK) | A count associated with an item that triggers a cost reduction as part of a DEAL. | QU_TH_UN_DL | Quantity | DECIMAL(9,3) | |
ChangeAmount | The additional allowance amount which is applied when the SUPPLIER's breakpoint is attained. | MO_CHN_CST_BRK | Money | decimal(16,5) | |
ChangePercent | The additional allowance percentage that is applied when the SUPPLIER's breakpoint is attained. | PE_CHN_CST_BRK | Percent | decimal(7,4) | |